TRAVERSE Global v11.1
Statement Contents
Use the Statement Contents function to specify the type of information to include in each row of the financial statement. General Ledger contains several statement contents that you can use or modify for your financial statements, but keep in mind that statement contents are highly dependent on the account structure you use for your accounts. While the statement contents provided with TRAVERSE work with sample data, you may need to modify them to work with your live data.
- The first content ID is displayed by default. Click the New button on the toolbar to open a blank statement contents record.
- To copy statement content information from a similar record for a new statement content, select the existing statement content from the Copy From field. If you are using one of the existing contents as a template it is recommended that you make a new contend ID and copy from the existing content you wish to use as a template. Edit the new content ID so the template stays as it is for future use, or if you need to delete the new content and start over.
- Enter the Name of the statement content in the field adjacent to the ID field.
- Select the ID of the company whose account mask you are using for the content from the Use Account Mask for Company ID field. You can use this same statement content ID for other companies on your system if they have the same account mask
- Enter a sequence number in the Seq No field.
Note: If you do not enter a sequence number, line numbers 10, 20, 30, and so on are entered for you. If you need to add a line between existing lines, enter a line number that is between the lines. For example, to insert a line between lines 10 and 20, enter a sequence number from 11 to 19. - Select the row type from the Type field.
Row Type Definitions
Type Code Definition Description AD Account Detail Will print a row for each account specified in the filter criteria box. AS Account Summary Will print one summary with the total of all the accounts specified in the filter criteria box. BB Beginning Balance of Year Will print a row for the beginning balances of the year for each account specified in the filter criteria box. BD Beginning Balance Detail Will print a row with the period beginning balances for each account specified in the filter criteria box. BS Beginning Balance Summary Will print one total row with the period beginning balances for the accounts specified in the filter criteria box. CL Shift Columns Left Will shift your number columns to the left the specified number of characters. CR Shift Columns Right Will shift your number columns to the right the specified number of characters. ED End Balance Detail Will print a row with the period ending balance for each account specified in the filter criteria box. ES End Balance Summary Will print a total row with the period ending balances for the accounts specified in the filter criteria box. T1 Total 1 Print the total stored so far in total bucket 1. T2 Total 2 Print the total stored so far in total bucket 2. T3 Total 3 Print the total stored so far in total bucket 3. T4 Total 4 Print the total stored so far in total bucket 4. T5 Total 5 Print the total stored so far in total bucket 5. T6 Total 6 Print the total stored so far in total bucket 6. T7 Total 7 Print the total stored so far in total bucket 7. T8 Total 8 Print the total stored so far in total bucket 8. T9 Total 9 Print the total stored so far in total bucket 9. US Single Underline Will print a single underline under the last number above the line. UD Double Underline Will print a double underline under the last number above the line. HC Center Heading Will print a heading in the middle of the margins. The text in the description field will be the heading. HP Print Heading Will print a heading left justified over the other descriptions. The text in the description field will be the heading. - Enter a description in the Description field. The description is printed on the statement. The availability of this field is dependent upon the row type.
- Enter, if you selected CL or CR in the Type field, the number of characters to shift the column left or right.
Note: This entry shifts numbers only. It does not shift the account ID and description. Columns are shifted only if the statement allows it. See Build Statements for more information. - Select the result of the row on the total accumulators for totals 1-9.
- Click the Detail button, if necessary, to specify the selected row's information or to enter information about new rows.
- Click the Save button, on the toolbar, to save the new statement content.
Enter | To |
+ | Increase the row total. |
- | Decrease the row total. |
0 | Zero out the row total. |
<blank> | Take no effect on the totals. |
Depending on the fields you selected via the Column Chooser, the same fields in the Detail screen may already appear on the Statement Contents screen.
-
If you selected AD, AS, BB, BD, BS, ED, or ES in the Type field, select the criterion for the row:
- Account ID: Account ID
- Account Type ID: Account Type
- Account Class ID: Account Class
- Seg1–7: segments 1 through 7, depending on the number of account segments you are using.
- Balance Type: debit accounts or credit accounts
- Currency ID: accounts with a specific currency
- Status: accounts with one of the statuses Active, Inactive or Discontinued
- Description: the account description or part of the description
Select the range of values, depending on the selected criterion.
- If you select Acct for the criterion, the available range is account IDs sorted by segments. For example, 1000-200-10 to 3000-200-10 selects account IDs where segment 1 is between 1000 and 3000, segment 2 is 200 and segment 3 is 10.
- If you select Type for the criterion, the available range is account type IDs. This will bring ALL accounts with the selected account type. You will have no option to limit by any segment numbers.
- If you select Class for the criterion, the available range is account classes. This will bring ALL accounts with the selected account class. You will have no option to limit by any segment numbers.
- If you select Seg1–7 for the criterion, the available range is segment values. This will bring ALL accounts with the selected segment number. You will have no option to limit by any other segment numbers.
When putting in the filter criteria values using the Acct selection, each segment is looked at independently from the other segments. For example if you have divisions 00 through 02 and departments 000 through 005. If your first cash account is 01-001-1000, but you have other accounts in division 00 and department 000 you must put 00-000-1000 to get the accounts in division 00 and department 000 to be included in your statement.
- Select whether to print debit, credit, or both account types from the Print Debits, Credits, or Both field.
- Select the company ID whose balances you want to print from the Company ID field; otherwise, leave the field blank. If you are using this content for multiple companies and you want the row to print for all companies, you MUST leave this field blank to bring information from other companies. This field is almost always left blank.
- To indent the row, enter the number of spaces in the Description Tab field. To refrain from indenting the row, enter 0 or leave the field blank.
For example, if you have your section headings left justified to the left margin and you want your account descriptions to be indented 2 spaces you would enter 2 here. Then if you wanted your total lines indented 2 more spaces you would enter 4 here.
-
When the row type is CL or CR, enter the # of Characters To Shift the row left or right.
This entry shifts numbers only. It does not shift the account ID and description. Columns are shifted only if the statement allows it.
- Enter the number of blank lines to print after the row in the Extra Blank Lines field. If you do not want a blank line, enter 0 or leave the field blank.
- Mark the Print Row check box to print the selected row; otherwise, clear the check box.
- Normally a negative sign is printed for all credit balances regardless of whether the account is a debit or credit account. Mark the Reverse Sign to Print check box, if applicable, if the accounts in the row are normally credit accounts so a negative sign is printed for any debit balances. Leave the check box blank if this row holds debit balances.
- Mark the Print Currency Symbol check box, if applicable, to print the currency symbols with the amounts.The currency symbol must also be included in the mask defined in the statement layout for the symbol to print when the box is checked.
- Mark the Page Break After check box to place a page break after the row. This will put the next row on a new page.
- Select the Action on Totals of the row on the total accumulators
- + -- if the row increases the total
- - -- if the row decreases the total
- 0 -- if the row zeros out the total
- Blank -- if the row has no effect on the total
- Close the Statement Contents - Detail screen to save any changes and return to the Statement Contents screen.
- Select a statement contents record to edit from the ID field.
- Edit the fields as necessary. If you are entering a new line, use the Add Record button () at the bottom of the screen. If you are deleting a line, use the Delete button () at the bottom of the screen.
- Click the Save button, on the toolbar, to save any changes made to the statement content record.
- Select the statement content record to delete from the ID field. You cannot delete a content ID that is currently being used in a statement.
- Click the Delete button, on the toolbar, to delete the selected statement content record.
- Click Yes at the "Are you sure you want to delete selected record(s)?" prompt.
Use the Statements List function to produce a list of defined statements.